﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="ReportingDataSet" targetNamespace="http://tempuri.org/ReportingDataSet.xsd" xmlns:mstns="http://tempuri.org/ReportingDataSet.xsd" xmlns="http://tempuri.org/ReportingDataSet.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="ReportingConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="ReportingConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.WaveTech.GShield.Manager.Properties.Settings.GlobalReference.Default.ReportingConnectionString" Provider="System.Data.SqlClient">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="BannedPolicyTableAdapter" GeneratorDataComponentClassName="BannedPolicyTableAdapter" Name="BannedPolicy" UserDataComponentName="BannedPolicyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.BannedPolicy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[BannedPolicy] WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_GameId = 1 AND [GameId] IS NULL) OR ([GameId] = @Original_GameId)) AND ((@IsNull_DateBanned = 1 AND [DateBanned] IS NULL) OR ([DateBanned] = @Original_DateBanned)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GameId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GameId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GameId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GameId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateBanned" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateBanned" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateBanned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateBanned" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[BannedPolicy] ([Username], [GameId], [DateBanned]) VALUES (@Username, @GameId, @DateBanned);
SELECT Id, Username, GameId, DateBanned FROM BannedPolicy WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GameId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GameId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateBanned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateBanned" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Id, Username, GameId, DateBanned FROM dbo.BannedPolicy</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[BannedPolicy] SET [Username] = @Username, [GameId] = @GameId, [DateBanned] = @DateBanned WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_GameId = 1 AND [GameId] IS NULL) OR ([GameId] = @Original_GameId)) AND ((@IsNull_DateBanned = 1 AND [DateBanned] IS NULL) OR ([DateBanned] = @Original_DateBanned)));
SELECT Id, Username, GameId, DateBanned FROM BannedPolicy WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@GameId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GameId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateBanned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateBanned" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_GameId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GameId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_GameId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="GameId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateBanned" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateBanned" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateBanned" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateBanned" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="GShield.dbo.BannedPolicy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="GameId" DataSetColumn="GameId" />
              <Mapping SourceColumn="DateBanned" DataSetColumn="DateBanned" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="GamesTableAdapter" GeneratorDataComponentClassName="GamesTableAdapter" Name="Games" UserDataComponentName="GamesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.Games" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Games] WHERE (([Id] = @Original_Id) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Publisher = 1 AND [Publisher] IS NULL) OR ([Publisher] = @Original_Publisher)) AND ((@IsNull_Content = 1 AND [Content] IS NULL) OR ([Content] = @Original_Content)) AND ((@IsNull_Rating = 1 AND [Rating] IS NULL) OR ([Rating] = @Original_Rating)) AND ((@IsNull_RatingType = 1 AND [RatingType] IS NULL) OR ([RatingType] = @Original_RatingType)) AND ((@IsNull_Platforms = 1 AND [Platforms] IS NULL) OR ([Platforms] = @Original_Platforms)) AND ((@IsNull_FileName = 1 AND [FileName] IS NULL) OR ([FileName] = @Original_FileName)) AND ((@IsNull_Path = 1 AND [Path] IS NULL) OR ([Path] = @Original_Path)) AND ((@IsNull_InternalName = 1 AND [InternalName] IS NULL) OR ([InternalName] = @Original_InternalName)) AND ((@IsNull_ProductName = 1 AND [ProductName] IS NULL) OR ([ProductName] = @Original_ProductName)) AND ((@IsNull_Company = 1 AND [Company] IS NULL) OR ([Company] = @Original_Company)) AND ((@IsNull_DirectoryName = 1 AND [DirectoryName] IS NULL) OR ([DirectoryName] = @Original_DirectoryName)) AND ((@IsNull_DateAdded = 1 AND [DateAdded] IS NULL) OR ([DateAdded] = @Original_DateAdded)) AND ((@IsNull_WasChecked = 1 AND [WasChecked] IS NULL) OR ([WasChecked] = @Original_WasChecked)) AND ((@IsNull_DateChecked = 1 AND [DateChecked] IS NULL) OR ([DateChecked] = @Original_DateChecked)) AND ((@IsNull_NotAGame = 1 AND [NotAGame] IS NULL) OR ([NotAGame] = @Original_NotAGame)) AND ((@IsNull_Hash = 1 AND [Hash] IS NULL) OR ([Hash] = @Original_Hash)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Publisher" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Publisher" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Content" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Content" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Rating" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RatingType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RatingType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RatingType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RatingType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Platforms" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Platforms" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Platforms" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Platforms" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FileName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FileName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Path" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Path" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Path" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Path" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InternalName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InternalName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_InternalName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="InternalName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Company" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DirectoryName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DirectoryName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DirectoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DirectoryName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateAdded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateAdded" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAdded" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WasChecked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WasChecked" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_WasChecked" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WasChecked" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateChecked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateChecked" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateChecked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateChecked" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NotAGame" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NotAGame" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NotAGame" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NotAGame" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Games] ([Name], [Publisher], [Content], [Rating], [RatingType], [Platforms], [FileName], [Path], [InternalName], [ProductName], [Company], [DirectoryName], [DateAdded], [WasChecked], [DateChecked], [NotAGame], [Hash]) VALUES (@Name, @Publisher, @Content, @Rating, @RatingType, @Platforms, @FileName, @Path, @InternalName, @ProductName, @Company, @DirectoryName, @DateAdded, @WasChecked, @DateChecked, @NotAGame, @Hash);
SELECT Id, Name, Publisher, [Content], Rating, RatingType, Platforms, FileName, Path, InternalName, ProductName, Company, DirectoryName, DateAdded, WasChecked, DateChecked, NotAGame, Hash FROM Games WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Publisher" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rating" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RatingType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RatingType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Platforms" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Platforms" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FileName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Path" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Path" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@InternalName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="InternalName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DirectoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DirectoryName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAdded" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@WasChecked" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WasChecked" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateChecked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateChecked" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NotAGame" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NotAGame" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Id, Name, Publisher, Content, Rating, RatingType, Platforms, FileName, Path, InternalName, ProductName, Company, DirectoryName, DateAdded, WasChecked, DateChecked, NotAGame, Hash FROM dbo.Games</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Games] SET [Name] = @Name, [Publisher] = @Publisher, [Content] = @Content, [Rating] = @Rating, [RatingType] = @RatingType, [Platforms] = @Platforms, [FileName] = @FileName, [Path] = @Path, [InternalName] = @InternalName, [ProductName] = @ProductName, [Company] = @Company, [DirectoryName] = @DirectoryName, [DateAdded] = @DateAdded, [WasChecked] = @WasChecked, [DateChecked] = @DateChecked, [NotAGame] = @NotAGame, [Hash] = @Hash WHERE (([Id] = @Original_Id) AND ((@IsNull_Name = 1 AND [Name] IS NULL) OR ([Name] = @Original_Name)) AND ((@IsNull_Publisher = 1 AND [Publisher] IS NULL) OR ([Publisher] = @Original_Publisher)) AND ((@IsNull_Content = 1 AND [Content] IS NULL) OR ([Content] = @Original_Content)) AND ((@IsNull_Rating = 1 AND [Rating] IS NULL) OR ([Rating] = @Original_Rating)) AND ((@IsNull_RatingType = 1 AND [RatingType] IS NULL) OR ([RatingType] = @Original_RatingType)) AND ((@IsNull_Platforms = 1 AND [Platforms] IS NULL) OR ([Platforms] = @Original_Platforms)) AND ((@IsNull_FileName = 1 AND [FileName] IS NULL) OR ([FileName] = @Original_FileName)) AND ((@IsNull_Path = 1 AND [Path] IS NULL) OR ([Path] = @Original_Path)) AND ((@IsNull_InternalName = 1 AND [InternalName] IS NULL) OR ([InternalName] = @Original_InternalName)) AND ((@IsNull_ProductName = 1 AND [ProductName] IS NULL) OR ([ProductName] = @Original_ProductName)) AND ((@IsNull_Company = 1 AND [Company] IS NULL) OR ([Company] = @Original_Company)) AND ((@IsNull_DirectoryName = 1 AND [DirectoryName] IS NULL) OR ([DirectoryName] = @Original_DirectoryName)) AND ((@IsNull_DateAdded = 1 AND [DateAdded] IS NULL) OR ([DateAdded] = @Original_DateAdded)) AND ((@IsNull_WasChecked = 1 AND [WasChecked] IS NULL) OR ([WasChecked] = @Original_WasChecked)) AND ((@IsNull_DateChecked = 1 AND [DateChecked] IS NULL) OR ([DateChecked] = @Original_DateChecked)) AND ((@IsNull_NotAGame = 1 AND [NotAGame] IS NULL) OR ([NotAGame] = @Original_NotAGame)) AND ((@IsNull_Hash = 1 AND [Hash] IS NULL) OR ([Hash] = @Original_Hash)));
SELECT Id, Name, Publisher, [Content], Rating, RatingType, Platforms, FileName, Path, InternalName, ProductName, Company, DirectoryName, DateAdded, WasChecked, DateChecked, NotAGame, Hash FROM Games WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Publisher" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Content" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Rating" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@RatingType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RatingType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Platforms" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Platforms" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FileName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Path" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Path" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@InternalName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="InternalName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DirectoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DirectoryName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAdded" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@WasChecked" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WasChecked" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@DateChecked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateChecked" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@NotAGame" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NotAGame" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Name" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Name" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Name" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Publisher" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Publisher" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Publisher" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Content" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Content" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Content" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Rating" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Rating" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Rating" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_RatingType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RatingType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_RatingType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="RatingType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Platforms" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Platforms" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Platforms" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Platforms" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FileName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FileName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FileName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Path" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Path" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Path" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Path" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_InternalName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="InternalName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_InternalName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="InternalName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ProductName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ProductName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ProductName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Company" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Company" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Company" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DirectoryName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DirectoryName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DirectoryName" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DirectoryName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateAdded" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateAdded" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateAdded" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateAdded" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WasChecked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WasChecked" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_WasChecked" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="WasChecked" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_DateChecked" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="DateChecked" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_DateChecked" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DateChecked" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_NotAGame" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NotAGame" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_NotAGame" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="NotAGame" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="GShield.dbo.Games" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Name" DataSetColumn="Name" />
              <Mapping SourceColumn="Publisher" DataSetColumn="Publisher" />
              <Mapping SourceColumn="Content" DataSetColumn="Content" />
              <Mapping SourceColumn="Rating" DataSetColumn="Rating" />
              <Mapping SourceColumn="RatingType" DataSetColumn="RatingType" />
              <Mapping SourceColumn="Platforms" DataSetColumn="Platforms" />
              <Mapping SourceColumn="FileName" DataSetColumn="FileName" />
              <Mapping SourceColumn="Path" DataSetColumn="Path" />
              <Mapping SourceColumn="InternalName" DataSetColumn="InternalName" />
              <Mapping SourceColumn="ProductName" DataSetColumn="ProductName" />
              <Mapping SourceColumn="Company" DataSetColumn="Company" />
              <Mapping SourceColumn="DirectoryName" DataSetColumn="DirectoryName" />
              <Mapping SourceColumn="DateAdded" DataSetColumn="DateAdded" />
              <Mapping SourceColumn="WasChecked" DataSetColumn="WasChecked" />
              <Mapping SourceColumn="DateChecked" DataSetColumn="DateChecked" />
              <Mapping SourceColumn="NotAGame" DataSetColumn="NotAGame" />
              <Mapping SourceColumn="Hash" DataSetColumn="Hash" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="LogTableAdapter" GeneratorDataComponentClassName="LogTableAdapter" Name="Log" UserDataComponentName="LogTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.[Log]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="False" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [Log] WHERE (([LogID] = @Original_LogID) AND ((@IsNull_EventID = 1 AND [EventID] IS NULL) OR ([EventID] = @Original_EventID)) AND ([Priority] = @Original_Priority) AND ([Severity] = @Original_Severity) AND ([Title] = @Original_Title) AND ([MachineName] = @Original_MachineName) AND ([AppDomainName] = @Original_AppDomainName) AND ([ProcessID] = @Original_ProcessID) AND ([ProcessName] = @Original_ProcessName) AND ((@IsNull_ThreadName = 1 AND [ThreadName] IS NULL) OR ([ThreadName] = @Original_ThreadName)) AND ((@IsNull_Win32ThreadId = 1 AND [Win32ThreadId] IS NULL) OR ([Win32ThreadId] = @Original_Win32ThreadId)) AND ([Timestamp] = @Original_Timestamp) AND ((@IsNull_Message = 1 AND [Message] IS NULL) OR ([Message] = @Original_Message)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LogID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LogID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Severity" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Severity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MachineName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MachineName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AppDomainName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AppDomainName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProcessID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProcessID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProcessName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProcessName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThreadName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThreadName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ThreadName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ThreadName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Win32ThreadId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Win32ThreadId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Win32ThreadId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Win32ThreadId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Message" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Message" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [Log] ([EventID], [Priority], [Severity], [Title], [MachineName], [AppDomainName], [ProcessID], [ProcessName], [ThreadName], [Win32ThreadId], [FormattedMessage], [Timestamp], [Message]) VALUES (@EventID, @Priority, @Severity, @Title, @MachineName, @AppDomainName, @ProcessID, @ProcessName, @ThreadName, @Win32ThreadId, @FormattedMessage, @Timestamp, @Message);
SELECT LogID, EventID, Priority, Severity, Title, MachineName, AppDomainName, ProcessID, ProcessName, ThreadName, Win32ThreadId, FormattedMessage, Timestamp, Message FROM [Log] WHERE (LogID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Severity" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Severity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MachineName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MachineName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AppDomainName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AppDomainName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProcessID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProcessID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProcessName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProcessName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ThreadName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ThreadName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Win32ThreadId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Win32ThreadId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FormattedMessage" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="FormattedMessage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Message" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT        LogID, EventID, Priority, Severity, Title, MachineName, AppDomainName, ProcessID, ProcessName, ThreadName, Win32ThreadId, FormattedMessage, 
                         Timestamp, Message
FROM            [Log]</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [Log] SET [EventID] = @EventID, [Priority] = @Priority, [Severity] = @Severity, [Title] = @Title, [MachineName] = @MachineName, [AppDomainName] = @AppDomainName, [ProcessID] = @ProcessID, [ProcessName] = @ProcessName, [ThreadName] = @ThreadName, [Win32ThreadId] = @Win32ThreadId, [FormattedMessage] = @FormattedMessage, [Timestamp] = @Timestamp, [Message] = @Message WHERE (([LogID] = @Original_LogID) AND ((@IsNull_EventID = 1 AND [EventID] IS NULL) OR ([EventID] = @Original_EventID)) AND ([Priority] = @Original_Priority) AND ([Severity] = @Original_Severity) AND ([Title] = @Original_Title) AND ([MachineName] = @Original_MachineName) AND ([AppDomainName] = @Original_AppDomainName) AND ([ProcessID] = @Original_ProcessID) AND ([ProcessName] = @Original_ProcessName) AND ((@IsNull_ThreadName = 1 AND [ThreadName] IS NULL) OR ([ThreadName] = @Original_ThreadName)) AND ((@IsNull_Win32ThreadId = 1 AND [Win32ThreadId] IS NULL) OR ([Win32ThreadId] = @Original_Win32ThreadId)) AND ([Timestamp] = @Original_Timestamp) AND ((@IsNull_Message = 1 AND [Message] IS NULL) OR ([Message] = @Original_Message)));
SELECT LogID, EventID, Priority, Severity, Title, MachineName, AppDomainName, ProcessID, ProcessName, ThreadName, Win32ThreadId, FormattedMessage, Timestamp, Message FROM [Log] WHERE (LogID = @LogID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Severity" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Severity" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@MachineName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MachineName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@AppDomainName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AppDomainName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProcessID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProcessID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ProcessName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProcessName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ThreadName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ThreadName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Win32ThreadId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Win32ThreadId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@FormattedMessage" Precision="0" ProviderType="NText" Scale="0" Size="0" SourceColumn="FormattedMessage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Message" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LogID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LogID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_EventID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EventID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Priority" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Priority" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Severity" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Severity" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Title" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Title" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_MachineName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="MachineName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_AppDomainName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="AppDomainName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProcessID" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProcessID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ProcessName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ProcessName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThreadName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThreadName" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ThreadName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ThreadName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Win32ThreadId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Win32ThreadId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Win32ThreadId" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Win32ThreadId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Message" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Message" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="LogID" ColumnName="LogID" DataSourceName="GShield.dbo.[Log]" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@LogID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="LogID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="LogID" DataSetColumn="LogID" />
              <Mapping SourceColumn="EventID" DataSetColumn="EventID" />
              <Mapping SourceColumn="Priority" DataSetColumn="Priority" />
              <Mapping SourceColumn="Severity" DataSetColumn="Severity" />
              <Mapping SourceColumn="Title" DataSetColumn="Title" />
              <Mapping SourceColumn="MachineName" DataSetColumn="MachineName" />
              <Mapping SourceColumn="AppDomainName" DataSetColumn="AppDomainName" />
              <Mapping SourceColumn="ProcessID" DataSetColumn="ProcessID" />
              <Mapping SourceColumn="ProcessName" DataSetColumn="ProcessName" />
              <Mapping SourceColumn="ThreadName" DataSetColumn="ThreadName" />
              <Mapping SourceColumn="Win32ThreadId" DataSetColumn="Win32ThreadId" />
              <Mapping SourceColumn="FormattedMessage" DataSetColumn="FormattedMessage" />
              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
              <Mapping SourceColumn="Message" DataSetColumn="Message" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RatingsPolicyTableAdapter" GeneratorDataComponentClassName="RatingsPolicyTableAdapter" Name="RatingsPolicy" UserDataComponentName="RatingsPolicyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.RatingsPolicy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[RatingsPolicy] WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_AllowEC = 1 AND [AllowEC] IS NULL) OR ([AllowEC] = @Original_AllowEC)) AND ((@IsNull_AllowE = 1 AND [AllowE] IS NULL) OR ([AllowE] = @Original_AllowE)) AND ((@IsNull_Allow10P = 1 AND [Allow10P] IS NULL) OR ([Allow10P] = @Original_Allow10P)) AND ((@IsNull_AllowT = 1 AND [AllowT] IS NULL) OR ([AllowT] = @Original_AllowT)) AND ((@IsNull_AllowM = 1 AND [AllowM] IS NULL) OR ([AllowM] = @Original_AllowM)) AND ((@IsNull_AllowAO = 1 AND [AllowAO] IS NULL) OR ([AllowAO] = @Original_AllowAO)) AND ((@IsNull_AllowRP = 1 AND [AllowRP] IS NULL) OR ([AllowRP] = @Original_AllowRP)) AND ((@IsNull_AllowUnknown = 1 AND [AllowUnknown] IS NULL) OR ([AllowUnknown] = @Original_AllowUnknown)) AND ((@IsNull_Hash = 1 AND [Hash] IS NULL) OR ([Hash] = @Original_Hash)) AND ((@IsNull_Timestamp = 1 AND [Timestamp] IS NULL) OR ([Timestamp] = @Original_Timestamp)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowEC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowEC" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowEC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowEC" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowE" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Allow10P" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Allow10P" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Allow10P" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Allow10P" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowM" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowM" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowAO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowAO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowAO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowAO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowRP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowRP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowRP" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowRP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowUnknown" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowUnknown" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowUnknown" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowUnknown" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[RatingsPolicy] ([Username], [AllowEC], [AllowE], [Allow10P], [AllowT], [AllowM], [AllowAO], [AllowRP], [AllowUnknown], [Hash], [Timestamp]) VALUES (@Username, @AllowEC, @AllowE, @Allow10P, @AllowT, @AllowM, @AllowAO, @AllowRP, @AllowUnknown, @Hash, @Timestamp);
SELECT Id, Username, AllowEC, AllowE, Allow10P, AllowT, AllowM, AllowAO, AllowRP, AllowUnknown, Hash, Timestamp FROM RatingsPolicy WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowEC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowEC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Allow10P" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Allow10P" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowM" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowAO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowAO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowRP" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowRP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowUnknown" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowUnknown" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Id, Username, AllowEC, AllowE, Allow10P, AllowT, AllowM, AllowAO, AllowRP, AllowUnknown, Hash, Timestamp FROM dbo.RatingsPolicy</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[RatingsPolicy] SET [Username] = @Username, [AllowEC] = @AllowEC, [AllowE] = @AllowE, [Allow10P] = @Allow10P, [AllowT] = @AllowT, [AllowM] = @AllowM, [AllowAO] = @AllowAO, [AllowRP] = @AllowRP, [AllowUnknown] = @AllowUnknown, [Hash] = @Hash, [Timestamp] = @Timestamp WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_AllowEC = 1 AND [AllowEC] IS NULL) OR ([AllowEC] = @Original_AllowEC)) AND ((@IsNull_AllowE = 1 AND [AllowE] IS NULL) OR ([AllowE] = @Original_AllowE)) AND ((@IsNull_Allow10P = 1 AND [Allow10P] IS NULL) OR ([Allow10P] = @Original_Allow10P)) AND ((@IsNull_AllowT = 1 AND [AllowT] IS NULL) OR ([AllowT] = @Original_AllowT)) AND ((@IsNull_AllowM = 1 AND [AllowM] IS NULL) OR ([AllowM] = @Original_AllowM)) AND ((@IsNull_AllowAO = 1 AND [AllowAO] IS NULL) OR ([AllowAO] = @Original_AllowAO)) AND ((@IsNull_AllowRP = 1 AND [AllowRP] IS NULL) OR ([AllowRP] = @Original_AllowRP)) AND ((@IsNull_AllowUnknown = 1 AND [AllowUnknown] IS NULL) OR ([AllowUnknown] = @Original_AllowUnknown)) AND ((@IsNull_Hash = 1 AND [Hash] IS NULL) OR ([Hash] = @Original_Hash)) AND ((@IsNull_Timestamp = 1 AND [Timestamp] IS NULL) OR ([Timestamp] = @Original_Timestamp)));
SELECT Id, Username, AllowEC, AllowE, Allow10P, AllowT, AllowM, AllowAO, AllowRP, AllowUnknown, Hash, Timestamp FROM RatingsPolicy WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowEC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowEC" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowE" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Allow10P" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Allow10P" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowT" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowM" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowM" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowAO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowAO" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowRP" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowRP" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@AllowUnknown" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowUnknown" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowEC" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowEC" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowEC" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowEC" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowE" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowE" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowE" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowE" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Allow10P" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Allow10P" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_Allow10P" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="Allow10P" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowT" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowT" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowT" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowM" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowM" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowM" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowM" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowAO" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowAO" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowAO" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowAO" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowRP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowRP" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowRP" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowRP" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_AllowUnknown" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="AllowUnknown" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_AllowUnknown" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="AllowUnknown" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="GShield.dbo.RatingsPolicy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="AllowEC" DataSetColumn="AllowEC" />
              <Mapping SourceColumn="AllowE" DataSetColumn="AllowE" />
              <Mapping SourceColumn="Allow10P" DataSetColumn="Allow10P" />
              <Mapping SourceColumn="AllowT" DataSetColumn="AllowT" />
              <Mapping SourceColumn="AllowM" DataSetColumn="AllowM" />
              <Mapping SourceColumn="AllowAO" DataSetColumn="AllowAO" />
              <Mapping SourceColumn="AllowRP" DataSetColumn="AllowRP" />
              <Mapping SourceColumn="AllowUnknown" DataSetColumn="AllowUnknown" />
              <Mapping SourceColumn="Hash" DataSetColumn="Hash" />
              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="TimesPolicyTableAdapter" GeneratorDataComponentClassName="TimesPolicyTableAdapter" Name="TimesPolicy" UserDataComponentName="TimesPolicyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.TimesPolicy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[TimesPolicy] WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate)) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)) AND ((@IsNull_MondayStart = 1 AND [MondayStart] IS NULL) OR ([MondayStart] = @Original_MondayStart)) AND ((@IsNull_MondayEnd = 1 AND [MondayEnd] IS NULL) OR ([MondayEnd] = @Original_MondayEnd)) AND ((@IsNull_TuesdayStart = 1 AND [TuesdayStart] IS NULL) OR ([TuesdayStart] = @Original_TuesdayStart)) AND ((@IsNull_TuesdayEnd = 1 AND [TuesdayEnd] IS NULL) OR ([TuesdayEnd] = @Original_TuesdayEnd)) AND ((@IsNull_WednesdayStart = 1 AND [WednesdayStart] IS NULL) OR ([WednesdayStart] = @Original_WednesdayStart)) AND ((@IsNull_WednesdayEnd = 1 AND [WednesdayEnd] IS NULL) OR ([WednesdayEnd] = @Original_WednesdayEnd)) AND ((@IsNull_ThursdayStart = 1 AND [ThursdayStart] IS NULL) OR ([ThursdayStart] = @Original_ThursdayStart)) AND ((@IsNull_ThursdayEnd = 1 AND [ThursdayEnd] IS NULL) OR ([ThursdayEnd] = @Original_ThursdayEnd)) AND ((@IsNull_FridayStart = 1 AND [FridayStart] IS NULL) OR ([FridayStart] = @Original_FridayStart)) AND ((@IsNull_FridayEnd = 1 AND [FridayEnd] IS NULL) OR ([FridayEnd] = @Original_FridayEnd)) AND ((@IsNull_SaturdayStart = 1 AND [SaturdayStart] IS NULL) OR ([SaturdayStart] = @Original_SaturdayStart)) AND ((@IsNull_SaturdayEnd = 1 AND [SaturdayEnd] IS NULL) OR ([SaturdayEnd] = @Original_SaturdayEnd)) AND ((@IsNull_SundayStart = 1 AND [SundayStart] IS NULL) OR ([SundayStart] = @Original_SundayStart)) AND ((@IsNull_SundayEnd = 1 AND [SundayEnd] IS NULL) OR ([SundayEnd] = @Original_SundayEnd)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MondayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MondayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MondayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MondayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MondayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MondayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TuesdayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TuesdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TuesdayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TuesdayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TuesdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TuesdayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WednesdayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_WednesdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WednesdayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WednesdayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_WednesdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WednesdayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThursdayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ThursdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ThursdayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThursdayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ThursdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ThursdayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FridayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FridayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FridayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FridayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FridayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FridayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SaturdayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SaturdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SaturdayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SaturdayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SaturdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SaturdayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SundayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SundayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SundayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SundayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SundayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SundayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[TimesPolicy] ([Username], [StartDate], [EndDate], [MondayStart], [MondayEnd], [TuesdayStart], [TuesdayEnd], [WednesdayStart], [WednesdayEnd], [ThursdayStart], [ThursdayEnd], [FridayStart], [FridayEnd], [SaturdayStart], [SaturdayEnd], [SundayStart], [SundayEnd]) VALUES (@Username, @StartDate, @EndDate, @MondayStart, @MondayEnd, @TuesdayStart, @TuesdayEnd, @WednesdayStart, @WednesdayEnd, @ThursdayStart, @ThursdayEnd, @FridayStart, @FridayEnd, @SaturdayStart, @SaturdayEnd, @SundayStart, @SundayEnd);
SELECT Id, Username, StartDate, EndDate, MondayStart, MondayEnd, TuesdayStart, TuesdayEnd, WednesdayStart, WednesdayEnd, ThursdayStart, ThursdayEnd, FridayStart, FridayEnd, SaturdayStart, SaturdayEnd, SundayStart, SundayEnd FROM TimesPolicy WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MondayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MondayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MondayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MondayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TuesdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TuesdayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TuesdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TuesdayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WednesdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WednesdayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WednesdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WednesdayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ThursdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ThursdayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ThursdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ThursdayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FridayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FridayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FridayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FridayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SaturdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SaturdayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SaturdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SaturdayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SundayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SundayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SundayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SundayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Id, Username, StartDate, EndDate, MondayStart, MondayEnd, TuesdayStart, TuesdayEnd, WednesdayStart, WednesdayEnd, ThursdayStart, ThursdayEnd, FridayStart, FridayEnd, SaturdayStart, SaturdayEnd, SundayStart, SundayEnd FROM dbo.TimesPolicy</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[TimesPolicy] SET [Username] = @Username, [StartDate] = @StartDate, [EndDate] = @EndDate, [MondayStart] = @MondayStart, [MondayEnd] = @MondayEnd, [TuesdayStart] = @TuesdayStart, [TuesdayEnd] = @TuesdayEnd, [WednesdayStart] = @WednesdayStart, [WednesdayEnd] = @WednesdayEnd, [ThursdayStart] = @ThursdayStart, [ThursdayEnd] = @ThursdayEnd, [FridayStart] = @FridayStart, [FridayEnd] = @FridayEnd, [SaturdayStart] = @SaturdayStart, [SaturdayEnd] = @SaturdayEnd, [SundayStart] = @SundayStart, [SundayEnd] = @SundayEnd WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate)) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)) AND ((@IsNull_MondayStart = 1 AND [MondayStart] IS NULL) OR ([MondayStart] = @Original_MondayStart)) AND ((@IsNull_MondayEnd = 1 AND [MondayEnd] IS NULL) OR ([MondayEnd] = @Original_MondayEnd)) AND ((@IsNull_TuesdayStart = 1 AND [TuesdayStart] IS NULL) OR ([TuesdayStart] = @Original_TuesdayStart)) AND ((@IsNull_TuesdayEnd = 1 AND [TuesdayEnd] IS NULL) OR ([TuesdayEnd] = @Original_TuesdayEnd)) AND ((@IsNull_WednesdayStart = 1 AND [WednesdayStart] IS NULL) OR ([WednesdayStart] = @Original_WednesdayStart)) AND ((@IsNull_WednesdayEnd = 1 AND [WednesdayEnd] IS NULL) OR ([WednesdayEnd] = @Original_WednesdayEnd)) AND ((@IsNull_ThursdayStart = 1 AND [ThursdayStart] IS NULL) OR ([ThursdayStart] = @Original_ThursdayStart)) AND ((@IsNull_ThursdayEnd = 1 AND [ThursdayEnd] IS NULL) OR ([ThursdayEnd] = @Original_ThursdayEnd)) AND ((@IsNull_FridayStart = 1 AND [FridayStart] IS NULL) OR ([FridayStart] = @Original_FridayStart)) AND ((@IsNull_FridayEnd = 1 AND [FridayEnd] IS NULL) OR ([FridayEnd] = @Original_FridayEnd)) AND ((@IsNull_SaturdayStart = 1 AND [SaturdayStart] IS NULL) OR ([SaturdayStart] = @Original_SaturdayStart)) AND ((@IsNull_SaturdayEnd = 1 AND [SaturdayEnd] IS NULL) OR ([SaturdayEnd] = @Original_SaturdayEnd)) AND ((@IsNull_SundayStart = 1 AND [SundayStart] IS NULL) OR ([SundayStart] = @Original_SundayStart)) AND ((@IsNull_SundayEnd = 1 AND [SundayEnd] IS NULL) OR ([SundayEnd] = @Original_SundayEnd)));
SELECT Id, Username, StartDate, EndDate, MondayStart, MondayEnd, TuesdayStart, TuesdayEnd, WednesdayStart, WednesdayEnd, ThursdayStart, ThursdayEnd, FridayStart, FridayEnd, SaturdayStart, SaturdayEnd, SundayStart, SundayEnd FROM TimesPolicy WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MondayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MondayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@MondayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MondayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TuesdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TuesdayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TuesdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TuesdayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WednesdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WednesdayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@WednesdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WednesdayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ThursdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ThursdayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@ThursdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ThursdayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FridayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FridayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@FridayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FridayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SaturdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SaturdayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SaturdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SaturdayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SundayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SundayStart" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@SundayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SundayEnd" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MondayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MondayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MondayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MondayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_MondayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="MondayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TuesdayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TuesdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TuesdayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TuesdayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TuesdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TuesdayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WednesdayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_WednesdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WednesdayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WednesdayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_WednesdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="WednesdayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThursdayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ThursdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ThursdayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThursdayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_ThursdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="ThursdayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FridayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FridayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FridayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FridayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_FridayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="FridayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SaturdayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SaturdayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SaturdayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SaturdayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SaturdayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SaturdayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SundayStart" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayStart" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SundayStart" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SundayStart" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SundayEnd" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayEnd" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_SundayEnd" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="SundayEnd" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="GShield.dbo.TimesPolicy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
              <Mapping SourceColumn="MondayStart" DataSetColumn="MondayStart" />
              <Mapping SourceColumn="MondayEnd" DataSetColumn="MondayEnd" />
              <Mapping SourceColumn="TuesdayStart" DataSetColumn="TuesdayStart" />
              <Mapping SourceColumn="TuesdayEnd" DataSetColumn="TuesdayEnd" />
              <Mapping SourceColumn="WednesdayStart" DataSetColumn="WednesdayStart" />
              <Mapping SourceColumn="WednesdayEnd" DataSetColumn="WednesdayEnd" />
              <Mapping SourceColumn="ThursdayStart" DataSetColumn="ThursdayStart" />
              <Mapping SourceColumn="ThursdayEnd" DataSetColumn="ThursdayEnd" />
              <Mapping SourceColumn="FridayStart" DataSetColumn="FridayStart" />
              <Mapping SourceColumn="FridayEnd" DataSetColumn="FridayEnd" />
              <Mapping SourceColumn="SaturdayStart" DataSetColumn="SaturdayStart" />
              <Mapping SourceColumn="SaturdayEnd" DataSetColumn="SaturdayEnd" />
              <Mapping SourceColumn="SundayStart" DataSetColumn="SundayStart" />
              <Mapping SourceColumn="SundayEnd" DataSetColumn="SundayEnd" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsagePolicyTableAdapter" GeneratorDataComponentClassName="UsagePolicyTableAdapter" Name="UsagePolicy" UserDataComponentName="UsagePolicyTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.UsagePolicy" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[UsagePolicy] WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate)) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)) AND ((@IsNull_Monday = 1 AND [Monday] IS NULL) OR ([Monday] = @Original_Monday)) AND ((@IsNull_MondayType = 1 AND [MondayType] IS NULL) OR ([MondayType] = @Original_MondayType)) AND ((@IsNull_Tuesday = 1 AND [Tuesday] IS NULL) OR ([Tuesday] = @Original_Tuesday)) AND ((@IsNull_TuesdayType = 1 AND [TuesdayType] IS NULL) OR ([TuesdayType] = @Original_TuesdayType)) AND ((@IsNull_Wednesday = 1 AND [Wednesday] IS NULL) OR ([Wednesday] = @Original_Wednesday)) AND ((@IsNull_WednesdayType = 1 AND [WednesdayType] IS NULL) OR ([WednesdayType] = @Original_WednesdayType)) AND ((@IsNull_Thursday = 1 AND [Thursday] IS NULL) OR ([Thursday] = @Original_Thursday)) AND ((@IsNull_ThursdayType = 1 AND [ThursdayType] IS NULL) OR ([ThursdayType] = @Original_ThursdayType)) AND ((@IsNull_Friday = 1 AND [Friday] IS NULL) OR ([Friday] = @Original_Friday)) AND ((@IsNull_FridayType = 1 AND [FridayType] IS NULL) OR ([FridayType] = @Original_FridayType)) AND ((@IsNull_Saturday = 1 AND [Saturday] IS NULL) OR ([Saturday] = @Original_Saturday)) AND ((@IsNull_SaturdayType = 1 AND [SaturdayType] IS NULL) OR ([SaturdayType] = @Original_SaturdayType)) AND ((@IsNull_Sunday = 1 AND [Sunday] IS NULL) OR ([Sunday] = @Original_Sunday)) AND ((@IsNull_SundayType = 1 AND [SundayType] IS NULL) OR ([SundayType] = @Original_SundayType)) AND ((@IsNull_Timestamp = 1 AND [Timestamp] IS NULL) OR ([Timestamp] = @Original_Timestamp)) AND ((@IsNull_Hash = 1 AND [Hash] IS NULL) OR ([Hash] = @Original_Hash)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Monday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Monday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MondayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MondayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tuesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Tuesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TuesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TuesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Wednesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Wednesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WednesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WednesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Thursday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Thursday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThursdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ThursdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Friday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Friday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FridayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FridayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Saturday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Saturday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SaturdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SaturdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sunday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Sunday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SundayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SundayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[UsagePolicy] ([Username], [StartDate], [EndDate], [Monday], [MondayType], [Tuesday], [TuesdayType], [Wednesday], [WednesdayType], [Thursday], [ThursdayType], [Friday], [FridayType], [Saturday], [SaturdayType], [Sunday], [SundayType], [Timestamp], [Hash]) VALUES (@Username, @StartDate, @EndDate, @Monday, @MondayType, @Tuesday, @TuesdayType, @Wednesday, @WednesdayType, @Thursday, @ThursdayType, @Friday, @FridayType, @Saturday, @SaturdayType, @Sunday, @SundayType, @Timestamp, @Hash);
SELECT Id, Username, StartDate, EndDate, Monday, MondayType, Tuesday, TuesdayType, Wednesday, WednesdayType, Thursday, ThursdayType, Friday, FridayType, Saturday, SaturdayType, Sunday, SundayType, Timestamp, Hash FROM UsagePolicy WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Monday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MondayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tuesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TuesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Wednesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WednesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Thursday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ThursdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Friday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FridayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Saturday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SaturdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Sunday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SundayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Id, Username, StartDate, EndDate, Monday, MondayType, Tuesday, TuesdayType, Wednesday, WednesdayType, Thursday, ThursdayType, Friday, FridayType, Saturday, SaturdayType, Sunday, SundayType, Timestamp, Hash FROM dbo.UsagePolicy</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[UsagePolicy] SET [Username] = @Username, [StartDate] = @StartDate, [EndDate] = @EndDate, [Monday] = @Monday, [MondayType] = @MondayType, [Tuesday] = @Tuesday, [TuesdayType] = @TuesdayType, [Wednesday] = @Wednesday, [WednesdayType] = @WednesdayType, [Thursday] = @Thursday, [ThursdayType] = @ThursdayType, [Friday] = @Friday, [FridayType] = @FridayType, [Saturday] = @Saturday, [SaturdayType] = @SaturdayType, [Sunday] = @Sunday, [SundayType] = @SundayType, [Timestamp] = @Timestamp, [Hash] = @Hash WHERE (([Id] = @Original_Id) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_StartDate = 1 AND [StartDate] IS NULL) OR ([StartDate] = @Original_StartDate)) AND ((@IsNull_EndDate = 1 AND [EndDate] IS NULL) OR ([EndDate] = @Original_EndDate)) AND ((@IsNull_Monday = 1 AND [Monday] IS NULL) OR ([Monday] = @Original_Monday)) AND ((@IsNull_MondayType = 1 AND [MondayType] IS NULL) OR ([MondayType] = @Original_MondayType)) AND ((@IsNull_Tuesday = 1 AND [Tuesday] IS NULL) OR ([Tuesday] = @Original_Tuesday)) AND ((@IsNull_TuesdayType = 1 AND [TuesdayType] IS NULL) OR ([TuesdayType] = @Original_TuesdayType)) AND ((@IsNull_Wednesday = 1 AND [Wednesday] IS NULL) OR ([Wednesday] = @Original_Wednesday)) AND ((@IsNull_WednesdayType = 1 AND [WednesdayType] IS NULL) OR ([WednesdayType] = @Original_WednesdayType)) AND ((@IsNull_Thursday = 1 AND [Thursday] IS NULL) OR ([Thursday] = @Original_Thursday)) AND ((@IsNull_ThursdayType = 1 AND [ThursdayType] IS NULL) OR ([ThursdayType] = @Original_ThursdayType)) AND ((@IsNull_Friday = 1 AND [Friday] IS NULL) OR ([Friday] = @Original_Friday)) AND ((@IsNull_FridayType = 1 AND [FridayType] IS NULL) OR ([FridayType] = @Original_FridayType)) AND ((@IsNull_Saturday = 1 AND [Saturday] IS NULL) OR ([Saturday] = @Original_Saturday)) AND ((@IsNull_SaturdayType = 1 AND [SaturdayType] IS NULL) OR ([SaturdayType] = @Original_SaturdayType)) AND ((@IsNull_Sunday = 1 AND [Sunday] IS NULL) OR ([Sunday] = @Original_Sunday)) AND ((@IsNull_SundayType = 1 AND [SundayType] IS NULL) OR ([SundayType] = @Original_SundayType)) AND ((@IsNull_Timestamp = 1 AND [Timestamp] IS NULL) OR ([Timestamp] = @Original_Timestamp)) AND ((@IsNull_Hash = 1 AND [Hash] IS NULL) OR ([Hash] = @Original_Hash)));
SELECT Id, Username, StartDate, EndDate, Monday, MondayType, Tuesday, TuesdayType, Wednesday, WednesdayType, Thursday, ThursdayType, Friday, FridayType, Saturday, SaturdayType, Sunday, SundayType, Timestamp, Hash FROM UsagePolicy WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Monday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@MondayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Tuesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TuesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Wednesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@WednesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Thursday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ThursdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Friday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@FridayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Saturday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SaturdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Sunday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@SundayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_StartDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_StartDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="StartDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_EndDate" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_EndDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="EndDate" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Monday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Monday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Monday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_MondayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_MondayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="MondayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Tuesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Tuesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Tuesday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TuesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TuesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TuesdayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Wednesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Wednesday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Wednesday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_WednesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_WednesdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="WednesdayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Thursday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Thursday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Thursday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ThursdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ThursdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ThursdayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Friday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Friday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Friday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_FridayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_FridayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="FridayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Saturday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Saturday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Saturday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SaturdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SaturdayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SaturdayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Sunday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Sunday" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Sunday" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_SundayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_SundayType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="SundayType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="GShield.dbo.UsagePolicy" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="StartDate" DataSetColumn="StartDate" />
              <Mapping SourceColumn="EndDate" DataSetColumn="EndDate" />
              <Mapping SourceColumn="Monday" DataSetColumn="Monday" />
              <Mapping SourceColumn="MondayType" DataSetColumn="MondayType" />
              <Mapping SourceColumn="Tuesday" DataSetColumn="Tuesday" />
              <Mapping SourceColumn="TuesdayType" DataSetColumn="TuesdayType" />
              <Mapping SourceColumn="Wednesday" DataSetColumn="Wednesday" />
              <Mapping SourceColumn="WednesdayType" DataSetColumn="WednesdayType" />
              <Mapping SourceColumn="Thursday" DataSetColumn="Thursday" />
              <Mapping SourceColumn="ThursdayType" DataSetColumn="ThursdayType" />
              <Mapping SourceColumn="Friday" DataSetColumn="Friday" />
              <Mapping SourceColumn="FridayType" DataSetColumn="FridayType" />
              <Mapping SourceColumn="Saturday" DataSetColumn="Saturday" />
              <Mapping SourceColumn="SaturdayType" DataSetColumn="SaturdayType" />
              <Mapping SourceColumn="Sunday" DataSetColumn="Sunday" />
              <Mapping SourceColumn="SundayType" DataSetColumn="SundayType" />
              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
              <Mapping SourceColumn="Hash" DataSetColumn="Hash" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoryTableAdapter" GeneratorDataComponentClassName="CategoryTableAdapter" Name="Category" UserDataComponentName="CategoryTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.Category" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[Category] WHERE (([CategoryID] = @Original_CategoryID) AND ([CategoryName] = @Original_CategoryName))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[Category] ([CategoryName]) VALUES (@CategoryName);
SELECT CategoryID, CategoryName FROM Category WHERE (CategoryID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT CategoryID, CategoryName FROM dbo.Category</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[Category] SET [CategoryName] = @CategoryName WHERE (([CategoryID] = @Original_CategoryID) AND ([CategoryName] = @Original_CategoryName));
SELECT CategoryID, CategoryName FROM Category WHERE (CategoryID = @CategoryID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@CategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_CategoryName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="CategoryName" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="CategoryID" ColumnName="CategoryID" DataSourceName="GShield.dbo.Category" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CategoryID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="CategoryName" DataSetColumn="CategoryName" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="CategoryLogTableAdapter" GeneratorDataComponentClassName="CategoryLogTableAdapter" Name="CategoryLog" UserDataComponentName="CategoryLogTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.CategoryLog" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[CategoryLog] WHERE (([CategoryLogID] = @Original_CategoryLogID) AND ([CategoryID] = @Original_CategoryID) AND ([LogID] = @Original_LogID))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryLogID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryLogID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LogID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LogID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[CategoryLog] ([CategoryID], [LogID]) VALUES (@CategoryID, @LogID);
SELECT CategoryLogID, CategoryID, LogID FROM CategoryLog WHERE (CategoryLogID = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LogID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LogID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT CategoryLogID, CategoryID, LogID FROM dbo.CategoryLog</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[CategoryLog] SET [CategoryID] = @CategoryID, [LogID] = @LogID WHERE (([CategoryLogID] = @Original_CategoryLogID) AND ([CategoryID] = @Original_CategoryID) AND ([LogID] = @Original_LogID));
SELECT CategoryLogID, CategoryID, LogID FROM CategoryLog WHERE (CategoryLogID = @CategoryLogID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@LogID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LogID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryLogID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryLogID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_CategoryID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="CategoryID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_LogID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="LogID" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="CategoryLogID" ColumnName="CategoryLogID" DataSourceName="GShield.dbo.CategoryLog" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@CategoryLogID" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="CategoryLogID" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="CategoryLogID" DataSetColumn="CategoryLogID" />
              <Mapping SourceColumn="CategoryID" DataSetColumn="CategoryID" />
              <Mapping SourceColumn="LogID" DataSetColumn="LogID" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsageLogsTableAdapter" GeneratorDataComponentClassName="UsageLogsTableAdapter" Name="UsageLogs" UserDataComponentName="UsageLogsTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="ReportingConnectionString (Settings)" DbObjectName="GShield.dbo.UsageLogs" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM [dbo].[UsageLogs] WHERE (([Id] = @Original_Id) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)) AND ((@IsNull_ParentId = 1 AND [ParentId] IS NULL) OR ([ParentId] = @Original_ParentId)) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Time = 1 AND [Time] IS NULL) OR ([Time] = @Original_Time)) AND ((@IsNull_TimeType = 1 AND [TimeType] IS NULL) OR ([TimeType] = @Original_TimeType)) AND ((@IsNull_Message = 1 AND [Message] IS NULL) OR ([Message] = @Original_Message)) AND ((@IsNull_Timestamp = 1 AND [Timestamp] IS NULL) OR ([Timestamp] = @Original_Timestamp)) AND ((@IsNull_Hash = 1 AND [Hash] IS NULL) OR ([Hash] = @Original_Hash)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Time" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TimeType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Message" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Message" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>INSERT INTO [dbo].[UsageLogs] ([Type], [ParentId], [Username], [Time], [TimeType], [Message], [Timestamp], [Hash]) VALUES (@Type, @ParentId, @Username, @Time, @TimeType, @Message, @Timestamp, @Hash);
SELECT Id, Type, ParentId, Username, Time, TimeType, Message, Timestamp, Hash FROM UsageLogs WHERE (Id = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TimeType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Message" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>SELECT Id, Type, ParentId, Username, Time, TimeType, Message, Timestamp, Hash FROM dbo.UsageLogs</CommandText>
                    <Parameters>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE [dbo].[UsageLogs] SET [Type] = @Type, [ParentId] = @ParentId, [Username] = @Username, [Time] = @Time, [TimeType] = @TimeType, [Message] = @Message, [Timestamp] = @Timestamp, [Hash] = @Hash WHERE (([Id] = @Original_Id) AND ((@IsNull_Type = 1 AND [Type] IS NULL) OR ([Type] = @Original_Type)) AND ((@IsNull_ParentId = 1 AND [ParentId] IS NULL) OR ([ParentId] = @Original_ParentId)) AND ((@IsNull_Username = 1 AND [Username] IS NULL) OR ([Username] = @Original_Username)) AND ((@IsNull_Time = 1 AND [Time] IS NULL) OR ([Time] = @Original_Time)) AND ((@IsNull_TimeType = 1 AND [TimeType] IS NULL) OR ([TimeType] = @Original_TimeType)) AND ((@IsNull_Message = 1 AND [Message] IS NULL) OR ([Message] = @Original_Message)) AND ((@IsNull_Timestamp = 1 AND [Timestamp] IS NULL) OR ([Timestamp] = @Original_Timestamp)) AND ((@IsNull_Hash = 1 AND [Hash] IS NULL) OR ([Hash] = @Original_Hash)));
SELECT Id, Type, ParentId, Username, Time, TimeType, Message, Timestamp, Hash FROM UsageLogs WHERE (Id = @Id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Time" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@TimeType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeType" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Message" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Id" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Type" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Type" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ParentId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ParentId" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Username" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Username" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Username" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Time" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_Time" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Time" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_TimeType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeType" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_TimeType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="TimeType" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Message" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Message" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Message" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Timestamp" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_Timestamp" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="Timestamp" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_Hash" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="True" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_Hash" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="Hash" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="Id" ColumnName="Id" DataSourceName="GShield.dbo.UsageLogs" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@Id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="Id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="Id" DataSetColumn="Id" />
              <Mapping SourceColumn="Type" DataSetColumn="Type" />
              <Mapping SourceColumn="ParentId" DataSetColumn="ParentId" />
              <Mapping SourceColumn="Username" DataSetColumn="Username" />
              <Mapping SourceColumn="Time" DataSetColumn="Time" />
              <Mapping SourceColumn="TimeType" DataSetColumn="TimeType" />
              <Mapping SourceColumn="Message" DataSetColumn="Message" />
              <Mapping SourceColumn="Timestamp" DataSetColumn="Timestamp" />
              <Mapping SourceColumn="Hash" DataSetColumn="Hash" />
            </Mappings>
            <Sources>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="ReportingDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ReportingDataSet" msprop:Generator_DataSetName="ReportingDataSet">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="BannedPolicy" msprop:Generator_UserTableName="BannedPolicy" msprop:Generator_RowDeletedName="BannedPolicyRowDeleted" msprop:Generator_RowChangedName="BannedPolicyRowChanged" msprop:Generator_RowClassName="BannedPolicyRow" msprop:Generator_RowChangingName="BannedPolicyRowChanging" msprop:Generator_RowEvArgName="BannedPolicyRowChangeEvent" msprop:Generator_RowEvHandlerName="BannedPolicyRowChangeEventHandler" msprop:Generator_TableClassName="BannedPolicyDataTable" msprop:Generator_TableVarName="tableBannedPolicy" msprop:Generator_RowDeletingName="BannedPolicyRowDeleting" msprop:Generator_TablePropName="BannedPolicy">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="GameId" msprop:Generator_UserColumnName="GameId" msprop:Generator_ColumnVarNameInTable="columnGameId" msprop:Generator_ColumnPropNameInRow="GameId" msprop:Generator_ColumnPropNameInTable="GameIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="DateBanned" msprop:Generator_UserColumnName="DateBanned" msprop:Generator_ColumnVarNameInTable="columnDateBanned" msprop:Generator_ColumnPropNameInRow="DateBanned" msprop:Generator_ColumnPropNameInTable="DateBannedColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Games" msprop:Generator_UserTableName="Games" msprop:Generator_RowDeletedName="GamesRowDeleted" msprop:Generator_RowChangedName="GamesRowChanged" msprop:Generator_RowClassName="GamesRow" msprop:Generator_RowChangingName="GamesRowChanging" msprop:Generator_RowEvArgName="GamesRowChangeEvent" msprop:Generator_RowEvHandlerName="GamesRowChangeEventHandler" msprop:Generator_TableClassName="GamesDataTable" msprop:Generator_TableVarName="tableGames" msprop:Generator_RowDeletingName="GamesRowDeleting" msprop:Generator_TablePropName="Games">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnPropNameInTable="NameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Publisher" msprop:Generator_UserColumnName="Publisher" msprop:Generator_ColumnVarNameInTable="columnPublisher" msprop:Generator_ColumnPropNameInRow="Publisher" msprop:Generator_ColumnPropNameInTable="PublisherColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Content" msprop:Generator_UserColumnName="Content" msprop:Generator_ColumnVarNameInTable="columnContent" msprop:Generator_ColumnPropNameInRow="Content" msprop:Generator_ColumnPropNameInTable="ContentColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Rating" msprop:Generator_UserColumnName="Rating" msprop:Generator_ColumnVarNameInTable="columnRating" msprop:Generator_ColumnPropNameInRow="Rating" msprop:Generator_ColumnPropNameInTable="RatingColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="RatingType" msprop:Generator_UserColumnName="RatingType" msprop:Generator_ColumnVarNameInTable="columnRatingType" msprop:Generator_ColumnPropNameInRow="RatingType" msprop:Generator_ColumnPropNameInTable="RatingTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Platforms" msprop:Generator_UserColumnName="Platforms" msprop:Generator_ColumnVarNameInTable="columnPlatforms" msprop:Generator_ColumnPropNameInRow="Platforms" msprop:Generator_ColumnPropNameInTable="PlatformsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FileName" msprop:Generator_UserColumnName="FileName" msprop:Generator_ColumnVarNameInTable="columnFileName" msprop:Generator_ColumnPropNameInRow="FileName" msprop:Generator_ColumnPropNameInTable="FileNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Path" msprop:Generator_UserColumnName="Path" msprop:Generator_ColumnVarNameInTable="columnPath" msprop:Generator_ColumnPropNameInRow="Path" msprop:Generator_ColumnPropNameInTable="PathColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="InternalName" msprop:Generator_UserColumnName="InternalName" msprop:Generator_ColumnVarNameInTable="columnInternalName" msprop:Generator_ColumnPropNameInRow="InternalName" msprop:Generator_ColumnPropNameInTable="InternalNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProductName" msprop:Generator_UserColumnName="ProductName" msprop:Generator_ColumnVarNameInTable="columnProductName" msprop:Generator_ColumnPropNameInRow="ProductName" msprop:Generator_ColumnPropNameInTable="ProductNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Company" msprop:Generator_UserColumnName="Company" msprop:Generator_ColumnVarNameInTable="columnCompany" msprop:Generator_ColumnPropNameInRow="Company" msprop:Generator_ColumnPropNameInTable="CompanyColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DirectoryName" msprop:Generator_UserColumnName="DirectoryName" msprop:Generator_ColumnVarNameInTable="columnDirectoryName" msprop:Generator_ColumnPropNameInRow="DirectoryName" msprop:Generator_ColumnPropNameInTable="DirectoryNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DateAdded" msprop:Generator_UserColumnName="DateAdded" msprop:Generator_ColumnVarNameInTable="columnDateAdded" msprop:Generator_ColumnPropNameInRow="DateAdded" msprop:Generator_ColumnPropNameInTable="DateAddedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="WasChecked" msprop:Generator_UserColumnName="WasChecked" msprop:Generator_ColumnVarNameInTable="columnWasChecked" msprop:Generator_ColumnPropNameInRow="WasChecked" msprop:Generator_ColumnPropNameInTable="WasCheckedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="DateChecked" msprop:Generator_UserColumnName="DateChecked" msprop:Generator_ColumnVarNameInTable="columnDateChecked" msprop:Generator_ColumnPropNameInRow="DateChecked" msprop:Generator_ColumnPropNameInTable="DateCheckedColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="NotAGame" msprop:Generator_UserColumnName="NotAGame" msprop:Generator_ColumnVarNameInTable="columnNotAGame" msprop:Generator_ColumnPropNameInRow="NotAGame" msprop:Generator_ColumnPropNameInTable="NotAGameColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Hash" msprop:Generator_UserColumnName="Hash" msprop:Generator_ColumnVarNameInTable="columnHash" msprop:Generator_ColumnPropNameInRow="Hash" msprop:Generator_ColumnPropNameInTable="HashColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Log" msprop:Generator_UserTableName="Log" msprop:Generator_RowDeletedName="LogRowDeleted" msprop:Generator_RowChangedName="LogRowChanged" msprop:Generator_RowClassName="LogRow" msprop:Generator_RowChangingName="LogRowChanging" msprop:Generator_RowEvArgName="LogRowChangeEvent" msprop:Generator_RowEvHandlerName="LogRowChangeEventHandler" msprop:Generator_TableClassName="LogDataTable" msprop:Generator_TableVarName="tableLog" msprop:Generator_RowDeletingName="LogRowDeleting" msprop:Generator_TablePropName="Log">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="LogID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="LogID" msprop:Generator_ColumnPropNameInRow="LogID" msprop:Generator_ColumnVarNameInTable="columnLogID" msprop:Generator_ColumnPropNameInTable="LogIDColumn" type="xs:int" />
              <xs:element name="EventID" msprop:Generator_UserColumnName="EventID" msprop:Generator_ColumnPropNameInRow="EventID" msprop:Generator_ColumnVarNameInTable="columnEventID" msprop:Generator_ColumnPropNameInTable="EventIDColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Priority" msprop:Generator_UserColumnName="Priority" msprop:Generator_ColumnPropNameInRow="Priority" msprop:Generator_ColumnVarNameInTable="columnPriority" msprop:Generator_ColumnPropNameInTable="PriorityColumn" type="xs:int" />
              <xs:element name="Severity" msprop:Generator_UserColumnName="Severity" msprop:Generator_ColumnPropNameInRow="Severity" msprop:Generator_ColumnVarNameInTable="columnSeverity" msprop:Generator_ColumnPropNameInTable="SeverityColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInTable="TitleColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MachineName" msprop:Generator_UserColumnName="MachineName" msprop:Generator_ColumnPropNameInRow="MachineName" msprop:Generator_ColumnVarNameInTable="columnMachineName" msprop:Generator_ColumnPropNameInTable="MachineNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="32" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AppDomainName" msprop:Generator_UserColumnName="AppDomainName" msprop:Generator_ColumnPropNameInRow="AppDomainName" msprop:Generator_ColumnVarNameInTable="columnAppDomainName" msprop:Generator_ColumnPropNameInTable="AppDomainNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProcessID" msprop:Generator_UserColumnName="ProcessID" msprop:Generator_ColumnPropNameInRow="ProcessID" msprop:Generator_ColumnVarNameInTable="columnProcessID" msprop:Generator_ColumnPropNameInTable="ProcessIDColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="256" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ProcessName" msprop:Generator_UserColumnName="ProcessName" msprop:Generator_ColumnPropNameInRow="ProcessName" msprop:Generator_ColumnVarNameInTable="columnProcessName" msprop:Generator_ColumnPropNameInTable="ProcessNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ThreadName" msprop:Generator_UserColumnName="ThreadName" msprop:Generator_ColumnPropNameInRow="ThreadName" msprop:Generator_ColumnVarNameInTable="columnThreadName" msprop:Generator_ColumnPropNameInTable="ThreadNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="512" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Win32ThreadId" msprop:Generator_UserColumnName="Win32ThreadId" msprop:Generator_ColumnPropNameInRow="Win32ThreadId" msprop:Generator_ColumnVarNameInTable="columnWin32ThreadId" msprop:Generator_ColumnPropNameInTable="Win32ThreadIdColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="128" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FormattedMessage" msprop:Generator_UserColumnName="FormattedMessage" msprop:Generator_ColumnPropNameInRow="FormattedMessage" msprop:Generator_ColumnVarNameInTable="columnFormattedMessage" msprop:Generator_ColumnPropNameInTable="FormattedMessageColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1073741823" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Timestamp" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:dateTime" />
              <xs:element name="Message" msprop:Generator_UserColumnName="Message" msprop:Generator_ColumnPropNameInRow="Message" msprop:Generator_ColumnVarNameInTable="columnMessage" msprop:Generator_ColumnPropNameInTable="MessageColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="1500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="RatingsPolicy" msprop:Generator_UserTableName="RatingsPolicy" msprop:Generator_RowDeletedName="RatingsPolicyRowDeleted" msprop:Generator_RowChangedName="RatingsPolicyRowChanged" msprop:Generator_RowClassName="RatingsPolicyRow" msprop:Generator_RowChangingName="RatingsPolicyRowChanging" msprop:Generator_RowEvArgName="RatingsPolicyRowChangeEvent" msprop:Generator_RowEvHandlerName="RatingsPolicyRowChangeEventHandler" msprop:Generator_TableClassName="RatingsPolicyDataTable" msprop:Generator_TableVarName="tableRatingsPolicy" msprop:Generator_RowDeletingName="RatingsPolicyRowDeleting" msprop:Generator_TablePropName="RatingsPolicy">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="AllowEC" msprop:Generator_UserColumnName="AllowEC" msprop:Generator_ColumnVarNameInTable="columnAllowEC" msprop:Generator_ColumnPropNameInRow="AllowEC" msprop:Generator_ColumnPropNameInTable="AllowECColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="AllowE" msprop:Generator_UserColumnName="AllowE" msprop:Generator_ColumnVarNameInTable="columnAllowE" msprop:Generator_ColumnPropNameInRow="AllowE" msprop:Generator_ColumnPropNameInTable="AllowEColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Allow10P" msprop:Generator_UserColumnName="Allow10P" msprop:Generator_ColumnVarNameInTable="columnAllow10P" msprop:Generator_ColumnPropNameInRow="Allow10P" msprop:Generator_ColumnPropNameInTable="Allow10PColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="AllowT" msprop:Generator_UserColumnName="AllowT" msprop:Generator_ColumnVarNameInTable="columnAllowT" msprop:Generator_ColumnPropNameInRow="AllowT" msprop:Generator_ColumnPropNameInTable="AllowTColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="AllowM" msprop:Generator_UserColumnName="AllowM" msprop:Generator_ColumnVarNameInTable="columnAllowM" msprop:Generator_ColumnPropNameInRow="AllowM" msprop:Generator_ColumnPropNameInTable="AllowMColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="AllowAO" msprop:Generator_UserColumnName="AllowAO" msprop:Generator_ColumnVarNameInTable="columnAllowAO" msprop:Generator_ColumnPropNameInRow="AllowAO" msprop:Generator_ColumnPropNameInTable="AllowAOColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="AllowRP" msprop:Generator_UserColumnName="AllowRP" msprop:Generator_ColumnVarNameInTable="columnAllowRP" msprop:Generator_ColumnPropNameInRow="AllowRP" msprop:Generator_ColumnPropNameInTable="AllowRPColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="AllowUnknown" msprop:Generator_UserColumnName="AllowUnknown" msprop:Generator_ColumnVarNameInTable="columnAllowUnknown" msprop:Generator_ColumnPropNameInRow="AllowUnknown" msprop:Generator_ColumnPropNameInTable="AllowUnknownColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Hash" msprop:Generator_UserColumnName="Hash" msprop:Generator_ColumnVarNameInTable="columnHash" msprop:Generator_ColumnPropNameInRow="Hash" msprop:Generator_ColumnPropNameInTable="HashColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Timestamp" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="TimesPolicy" msprop:Generator_UserTableName="TimesPolicy" msprop:Generator_RowDeletedName="TimesPolicyRowDeleted" msprop:Generator_RowChangedName="TimesPolicyRowChanged" msprop:Generator_RowClassName="TimesPolicyRow" msprop:Generator_RowChangingName="TimesPolicyRowChanging" msprop:Generator_RowEvArgName="TimesPolicyRowChangeEvent" msprop:Generator_RowEvHandlerName="TimesPolicyRowChangeEventHandler" msprop:Generator_TableClassName="TimesPolicyDataTable" msprop:Generator_TableVarName="tableTimesPolicy" msprop:Generator_RowDeletingName="TimesPolicyRowDeleting" msprop:Generator_TablePropName="TimesPolicy">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndDate" msprop:Generator_UserColumnName="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="MondayStart" msprop:Generator_UserColumnName="MondayStart" msprop:Generator_ColumnVarNameInTable="columnMondayStart" msprop:Generator_ColumnPropNameInRow="MondayStart" msprop:Generator_ColumnPropNameInTable="MondayStartColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="MondayEnd" msprop:Generator_UserColumnName="MondayEnd" msprop:Generator_ColumnVarNameInTable="columnMondayEnd" msprop:Generator_ColumnPropNameInRow="MondayEnd" msprop:Generator_ColumnPropNameInTable="MondayEndColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TuesdayStart" msprop:Generator_UserColumnName="TuesdayStart" msprop:Generator_ColumnVarNameInTable="columnTuesdayStart" msprop:Generator_ColumnPropNameInRow="TuesdayStart" msprop:Generator_ColumnPropNameInTable="TuesdayStartColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="TuesdayEnd" msprop:Generator_UserColumnName="TuesdayEnd" msprop:Generator_ColumnVarNameInTable="columnTuesdayEnd" msprop:Generator_ColumnPropNameInRow="TuesdayEnd" msprop:Generator_ColumnPropNameInTable="TuesdayEndColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WednesdayStart" msprop:Generator_UserColumnName="WednesdayStart" msprop:Generator_ColumnVarNameInTable="columnWednesdayStart" msprop:Generator_ColumnPropNameInRow="WednesdayStart" msprop:Generator_ColumnPropNameInTable="WednesdayStartColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="WednesdayEnd" msprop:Generator_UserColumnName="WednesdayEnd" msprop:Generator_ColumnVarNameInTable="columnWednesdayEnd" msprop:Generator_ColumnPropNameInRow="WednesdayEnd" msprop:Generator_ColumnPropNameInTable="WednesdayEndColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ThursdayStart" msprop:Generator_UserColumnName="ThursdayStart" msprop:Generator_ColumnVarNameInTable="columnThursdayStart" msprop:Generator_ColumnPropNameInRow="ThursdayStart" msprop:Generator_ColumnPropNameInTable="ThursdayStartColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ThursdayEnd" msprop:Generator_UserColumnName="ThursdayEnd" msprop:Generator_ColumnVarNameInTable="columnThursdayEnd" msprop:Generator_ColumnPropNameInRow="ThursdayEnd" msprop:Generator_ColumnPropNameInTable="ThursdayEndColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FridayStart" msprop:Generator_UserColumnName="FridayStart" msprop:Generator_ColumnVarNameInTable="columnFridayStart" msprop:Generator_ColumnPropNameInRow="FridayStart" msprop:Generator_ColumnPropNameInTable="FridayStartColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="FridayEnd" msprop:Generator_UserColumnName="FridayEnd" msprop:Generator_ColumnVarNameInTable="columnFridayEnd" msprop:Generator_ColumnPropNameInRow="FridayEnd" msprop:Generator_ColumnPropNameInTable="FridayEndColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SaturdayStart" msprop:Generator_UserColumnName="SaturdayStart" msprop:Generator_ColumnVarNameInTable="columnSaturdayStart" msprop:Generator_ColumnPropNameInRow="SaturdayStart" msprop:Generator_ColumnPropNameInTable="SaturdayStartColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SaturdayEnd" msprop:Generator_UserColumnName="SaturdayEnd" msprop:Generator_ColumnVarNameInTable="columnSaturdayEnd" msprop:Generator_ColumnPropNameInRow="SaturdayEnd" msprop:Generator_ColumnPropNameInTable="SaturdayEndColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SundayStart" msprop:Generator_UserColumnName="SundayStart" msprop:Generator_ColumnVarNameInTable="columnSundayStart" msprop:Generator_ColumnPropNameInRow="SundayStart" msprop:Generator_ColumnPropNameInTable="SundayStartColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="SundayEnd" msprop:Generator_UserColumnName="SundayEnd" msprop:Generator_ColumnVarNameInTable="columnSundayEnd" msprop:Generator_ColumnPropNameInRow="SundayEnd" msprop:Generator_ColumnPropNameInTable="SundayEndColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="5" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UsagePolicy" msprop:Generator_UserTableName="UsagePolicy" msprop:Generator_RowDeletedName="UsagePolicyRowDeleted" msprop:Generator_RowChangedName="UsagePolicyRowChanged" msprop:Generator_RowClassName="UsagePolicyRow" msprop:Generator_RowChangingName="UsagePolicyRowChanging" msprop:Generator_RowEvArgName="UsagePolicyRowChangeEvent" msprop:Generator_RowEvHandlerName="UsagePolicyRowChangeEventHandler" msprop:Generator_TableClassName="UsagePolicyDataTable" msprop:Generator_TableVarName="tableUsagePolicy" msprop:Generator_RowDeletingName="UsagePolicyRowDeleting" msprop:Generator_TablePropName="UsagePolicy">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnPropNameInTable="UsernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="StartDate" msprop:Generator_UserColumnName="StartDate" msprop:Generator_ColumnVarNameInTable="columnStartDate" msprop:Generator_ColumnPropNameInRow="StartDate" msprop:Generator_ColumnPropNameInTable="StartDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="EndDate" msprop:Generator_UserColumnName="EndDate" msprop:Generator_ColumnVarNameInTable="columnEndDate" msprop:Generator_ColumnPropNameInRow="EndDate" msprop:Generator_ColumnPropNameInTable="EndDateColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Monday" msprop:Generator_UserColumnName="Monday" msprop:Generator_ColumnVarNameInTable="columnMonday" msprop:Generator_ColumnPropNameInRow="Monday" msprop:Generator_ColumnPropNameInTable="MondayColumn" type="xs:int" minOccurs="0" />
              <xs:element name="MondayType" msprop:Generator_UserColumnName="MondayType" msprop:Generator_ColumnVarNameInTable="columnMondayType" msprop:Generator_ColumnPropNameInRow="MondayType" msprop:Generator_ColumnPropNameInTable="MondayTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Tuesday" msprop:Generator_UserColumnName="Tuesday" msprop:Generator_ColumnVarNameInTable="columnTuesday" msprop:Generator_ColumnPropNameInRow="Tuesday" msprop:Generator_ColumnPropNameInTable="TuesdayColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TuesdayType" msprop:Generator_UserColumnName="TuesdayType" msprop:Generator_ColumnVarNameInTable="columnTuesdayType" msprop:Generator_ColumnPropNameInRow="TuesdayType" msprop:Generator_ColumnPropNameInTable="TuesdayTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Wednesday" msprop:Generator_UserColumnName="Wednesday" msprop:Generator_ColumnVarNameInTable="columnWednesday" msprop:Generator_ColumnPropNameInRow="Wednesday" msprop:Generator_ColumnPropNameInTable="WednesdayColumn" type="xs:int" minOccurs="0" />
              <xs:element name="WednesdayType" msprop:Generator_UserColumnName="WednesdayType" msprop:Generator_ColumnVarNameInTable="columnWednesdayType" msprop:Generator_ColumnPropNameInRow="WednesdayType" msprop:Generator_ColumnPropNameInTable="WednesdayTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Thursday" msprop:Generator_UserColumnName="Thursday" msprop:Generator_ColumnVarNameInTable="columnThursday" msprop:Generator_ColumnPropNameInRow="Thursday" msprop:Generator_ColumnPropNameInTable="ThursdayColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ThursdayType" msprop:Generator_UserColumnName="ThursdayType" msprop:Generator_ColumnVarNameInTable="columnThursdayType" msprop:Generator_ColumnPropNameInRow="ThursdayType" msprop:Generator_ColumnPropNameInTable="ThursdayTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Friday" msprop:Generator_UserColumnName="Friday" msprop:Generator_ColumnVarNameInTable="columnFriday" msprop:Generator_ColumnPropNameInRow="Friday" msprop:Generator_ColumnPropNameInTable="FridayColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FridayType" msprop:Generator_UserColumnName="FridayType" msprop:Generator_ColumnVarNameInTable="columnFridayType" msprop:Generator_ColumnPropNameInRow="FridayType" msprop:Generator_ColumnPropNameInTable="FridayTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Saturday" msprop:Generator_UserColumnName="Saturday" msprop:Generator_ColumnVarNameInTable="columnSaturday" msprop:Generator_ColumnPropNameInRow="Saturday" msprop:Generator_ColumnPropNameInTable="SaturdayColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SaturdayType" msprop:Generator_UserColumnName="SaturdayType" msprop:Generator_ColumnVarNameInTable="columnSaturdayType" msprop:Generator_ColumnPropNameInRow="SaturdayType" msprop:Generator_ColumnPropNameInTable="SaturdayTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Sunday" msprop:Generator_UserColumnName="Sunday" msprop:Generator_ColumnVarNameInTable="columnSunday" msprop:Generator_ColumnPropNameInRow="Sunday" msprop:Generator_ColumnPropNameInTable="SundayColumn" type="xs:int" minOccurs="0" />
              <xs:element name="SundayType" msprop:Generator_UserColumnName="SundayType" msprop:Generator_ColumnVarNameInTable="columnSundayType" msprop:Generator_ColumnPropNameInRow="SundayType" msprop:Generator_ColumnPropNameInTable="SundayTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Timestamp" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Hash" msprop:Generator_UserColumnName="Hash" msprop:Generator_ColumnVarNameInTable="columnHash" msprop:Generator_ColumnPropNameInRow="Hash" msprop:Generator_ColumnPropNameInTable="HashColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="Category" msprop:Generator_UserTableName="Category" msprop:Generator_RowDeletedName="CategoryRowDeleted" msprop:Generator_TableClassName="CategoryDataTable" msprop:Generator_RowChangedName="CategoryRowChanged" msprop:Generator_RowClassName="CategoryRow" msprop:Generator_RowChangingName="CategoryRowChanging" msprop:Generator_RowEvArgName="CategoryRowChangeEvent" msprop:Generator_RowEvHandlerName="CategoryRowChangeEventHandler" msprop:Generator_TablePropName="Category" msprop:Generator_TableVarName="tableCategory" msprop:Generator_RowDeletingName="CategoryRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="CategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" type="xs:int" />
              <xs:element name="CategoryName" msprop:Generator_UserColumnName="CategoryName" msprop:Generator_ColumnPropNameInRow="CategoryName" msprop:Generator_ColumnVarNameInTable="columnCategoryName" msprop:Generator_ColumnPropNameInTable="CategoryNameColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="64" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="CategoryLog" msprop:Generator_UserTableName="CategoryLog" msprop:Generator_RowDeletedName="CategoryLogRowDeleted" msprop:Generator_TableClassName="CategoryLogDataTable" msprop:Generator_RowChangedName="CategoryLogRowChanged" msprop:Generator_RowClassName="CategoryLogRow" msprop:Generator_RowChangingName="CategoryLogRowChanging" msprop:Generator_RowEvArgName="CategoryLogRowChangeEvent" msprop:Generator_RowEvHandlerName="CategoryLogRowChangeEventHandler" msprop:Generator_TablePropName="CategoryLog" msprop:Generator_TableVarName="tableCategoryLog" msprop:Generator_RowDeletingName="CategoryLogRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="CategoryLogID" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="CategoryLogID" msprop:Generator_ColumnPropNameInRow="CategoryLogID" msprop:Generator_ColumnVarNameInTable="columnCategoryLogID" msprop:Generator_ColumnPropNameInTable="CategoryLogIDColumn" type="xs:int" />
              <xs:element name="CategoryID" msprop:Generator_UserColumnName="CategoryID" msprop:Generator_ColumnPropNameInRow="CategoryID" msprop:Generator_ColumnVarNameInTable="columnCategoryID" msprop:Generator_ColumnPropNameInTable="CategoryIDColumn" type="xs:int" />
              <xs:element name="LogID" msprop:Generator_UserColumnName="LogID" msprop:Generator_ColumnPropNameInRow="LogID" msprop:Generator_ColumnVarNameInTable="columnLogID" msprop:Generator_ColumnPropNameInTable="LogIDColumn" type="xs:int" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="UsageLogs" msprop:Generator_UserTableName="UsageLogs" msprop:Generator_RowDeletedName="UsageLogsRowDeleted" msprop:Generator_TableClassName="UsageLogsDataTable" msprop:Generator_RowChangedName="UsageLogsRowChanged" msprop:Generator_RowClassName="UsageLogsRow" msprop:Generator_RowChangingName="UsageLogsRowChanging" msprop:Generator_RowEvArgName="UsageLogsRowChangeEvent" msprop:Generator_RowEvHandlerName="UsageLogsRowChangeEventHandler" msprop:Generator_TablePropName="UsageLogs" msprop:Generator_TableVarName="tableUsageLogs" msprop:Generator_RowDeletingName="UsageLogsRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="Id" msdata:ReadOnly="true" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="Id" msprop:Generator_ColumnPropNameInRow="Id" msprop:Generator_ColumnVarNameInTable="columnId" msprop:Generator_ColumnPropNameInTable="IdColumn" type="xs:int" />
              <xs:element name="Type" msprop:Generator_UserColumnName="Type" msprop:Generator_ColumnPropNameInRow="Type" msprop:Generator_ColumnVarNameInTable="columnType" msprop:Generator_ColumnPropNameInTable="TypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="ParentId" msprop:Generator_UserColumnName="ParentId" msprop:Generator_ColumnPropNameInRow="ParentId" msprop:Generator_ColumnVarNameInTable="columnParentId" msprop:Generator_ColumnPropNameInTable="ParentIdColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Username" msprop:Generator_UserColumnName="Username" msprop:Generator_ColumnPropNameInRow="Username" msprop:Generator_ColumnVarNameInTable="columnUsername" msprop:Generator_ColumnPropNameInTable="UsernameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Time" msprop:Generator_UserColumnName="Time" msprop:Generator_ColumnPropNameInRow="Time" msprop:Generator_ColumnVarNameInTable="columnTime" msprop:Generator_ColumnPropNameInTable="TimeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="TimeType" msprop:Generator_UserColumnName="TimeType" msprop:Generator_ColumnPropNameInRow="TimeType" msprop:Generator_ColumnVarNameInTable="columnTimeType" msprop:Generator_ColumnPropNameInTable="TimeTypeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Message" msprop:Generator_UserColumnName="Message" msprop:Generator_ColumnPropNameInRow="Message" msprop:Generator_ColumnVarNameInTable="columnMessage" msprop:Generator_ColumnPropNameInTable="MessageColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Timestamp" msprop:Generator_UserColumnName="Timestamp" msprop:Generator_ColumnPropNameInRow="Timestamp" msprop:Generator_ColumnVarNameInTable="columnTimestamp" msprop:Generator_ColumnPropNameInTable="TimestampColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Hash" msprop:Generator_UserColumnName="Hash" msprop:Generator_ColumnPropNameInRow="Hash" msprop:Generator_ColumnVarNameInTable="columnHash" msprop:Generator_ColumnPropNameInTable="HashColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:BannedPolicy" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Games_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Games" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Log_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Log" />
      <xs:field xpath="mstns:LogID" />
    </xs:unique>
    <xs:unique name="RatingsPolicy_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:RatingsPolicy" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="TimesPolicy_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:TimesPolicy" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="UsagePolicy_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UsagePolicy" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
    <xs:unique name="Category_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Category" />
      <xs:field xpath="mstns:CategoryID" />
    </xs:unique>
    <xs:unique name="CategoryLog_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:CategoryLog" />
      <xs:field xpath="mstns:CategoryLogID" />
    </xs:unique>
    <xs:unique name="UsageLogs_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:UsageLogs" />
      <xs:field xpath="mstns:Id" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_CategoryLog_Category" msdata:parent="Category" msdata:child="CategoryLog" msdata:parentkey="CategoryID" msdata:childkey="CategoryID" msprop:Generator_UserRelationName="FK_CategoryLog_Category" msprop:Generator_RelationVarName="relationFK_CategoryLog_Category" msprop:Generator_UserChildTable="CategoryLog" msprop:Generator_UserParentTable="Category" msprop:Generator_ParentPropName="CategoryRow" msprop:Generator_ChildPropName="GetCategoryLogRows" />
      <msdata:Relationship name="BannedPolicy_Games" msdata:parent="BannedPolicy" msdata:child="Games" msdata:parentkey="GameId" msdata:childkey="Id" msprop:Generator_UserRelationName="BannedPolicy_Games" msprop:Generator_RelationVarName="relationBannedPolicy_Games" msprop:Generator_UserChildTable="Games" msprop:Generator_UserParentTable="BannedPolicy" msprop:Generator_ParentPropName="BannedPolicyRow" msprop:Generator_ChildPropName="GetGamesRows" />
      <msdata:Relationship name="UsageLogs_Games" msdata:parent="UsageLogs" msdata:child="Games" msdata:parentkey="ParentId" msdata:childkey="Id" msprop:Generator_UserRelationName="UsageLogs_Games" msprop:Generator_RelationVarName="relationUsageLogs_Games" msprop:Generator_UserChildTable="Games" msprop:Generator_UserParentTable="UsageLogs" msprop:Generator_ParentPropName="UsageLogsRow" msprop:Generator_ChildPropName="GetGamesRows" />
      <msdata:Relationship name="Log_CategoryLog" msdata:parent="Log" msdata:child="CategoryLog" msdata:parentkey="LogID" msdata:childkey="LogID" msprop:Generator_UserRelationName="Log_CategoryLog" msprop:Generator_RelationVarName="relationLog_CategoryLog" msprop:Generator_UserChildTable="CategoryLog" msprop:Generator_UserParentTable="Log" msprop:Generator_ParentPropName="LogRow" msprop:Generator_ChildPropName="GetCategoryLogRows" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>